--[[
    编码: WMS-71-22
    名称: 库存量表差异-查询面板-查询
    作者：HAN  
    日期：2025-1-29
    级别：固定 (说明本段代码在项目中不太会变化)
    
    函数： Query

    功能:
        根据查询面板里的输入，组成SQL的查询条件
    更改记录:
--]]

json  = require ("json")
mobox = require ("OILua_JavelinExt")
m3 = require("oi_base_mobox")

function Query ( strLuaDEID ) 
    local nRet, strRetInfo
    local parameter = {}
    local strSQL = ''
    
    -- 获取查询面板里的输入属性
    nRet, attrs = m3.GetSysInputParameter( strLuaDEID ) 
    if ( nRet ~= 0 )  then lua.Error( strLuaDEID, debug.getinfo(1), "m3.GetSysInputParameter 失败! "..attrs ) end 
    parameter = m3.KeyValueAttrsToObjAttr( attrs )

    if (#parameter.Filterate == 1 ) then
        strSQL = "C_DIFFERENCE = 'Y'"
    end

    if (#parameter.CGDetail == 1 ) then
        if ( strSQL ~= '' ) then strSQL = strSQL.." AND " end
        strSQL = "( F_QTY < 0 OR F_ALLOC_QTY < 0 )"
    end    
    -- 设置查询面板
    local setAttr = '{"condition":"'..strSQL..'","order":"S_ITEM_CODE"}'
    local strAction = '[{"action_type":"set_query_condition","value":'..setAttr..'}]'
    nRet, strRetInfo = mobox.setAction( strLuaDEID, strAction  )
    if ( nRet ~= 0 ) then lua.Error( strLuaDEID, debug.getinfo(1), "setAction失败! "..strRetInfo..' action = '..strAction ) end 

end